CREATE TABLES

---

MySQL - CREATE TABLES

The 'CREATE TABLE' Statement :

This statement is used to create a new table in a database.

SYNTAX 

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
   ....
);

Example:

CREATE TABLE Students
(
StudentID int,
StudentName varchar(255),
ParentName varchar(255),
Address varchar(255),
PostalCode int,
City varchar(255)
);

As a result the following table gets created:

StudentID	StudentName	ParentName	Address	PostalCode	City
NULL	NULL	NULL	NULL	NULL	NULL